| FaCODGrantDisb |
| Logical Entity Name | FaCODGrantDisb |
| Default Table Name | FaCODGrantDisb |
| Physical Only | NO |
| Definition | |
| Note |
| FaCODGrantDisb Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
FaCODGrantDisbId |
int | NO | ||
FaCODGrantID |
int | NO | ||
FaStudentAidID |
int | NO | ||
FaSchedID |
int | YES | ||
FaDisbID |
int | YES | ||
FaRefundID |
int | YES | ||
| DisbNum | int | NO | ||
| DisbSequenceNum | int | NO | ||
| DisbDate | datetime | NO | ||
| DisbAmount | money | NO | ||
| YTDDisbAmount | money | YES | ||
| AcceptedDisbAmount | money | YES | ||
| ExportBatchID | varchar(30) | YES | ||
| CODDisbStatus | char(1) | NO | ||
| CODRejectCodes | varchar(100) | YES | ||
| DateSent | datetime | YES | ||
UserID |
int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ModFlag | char(1) | NO | ||
| ts | timestamp | NO | ||
| TotalEligibilityUsed | money | YES | ||
| BookAmount | money | YES | ||
| BookDate | datetime | YES | ||
| BookStatus | char(1) | YES | ||
| PrevDisbSequenceNum | int | YES | ||
| PublishedPgmLengthValue | numeric(7, 3) | YES | ||
| PublishedPgmLengthType | char(1) | YES |
| FaCODGrantDisb Primary and Unique Keys |
| Key Name | Key Type | Keys |
| FaCODGrantDisb_FaCODGrantID_DisbNum_DisbSequenceNum_U_N_IDX | Index | FaCODGrantID, DisbNum, DisbSequenceNum |
| FaCODGrantDisb_ExportBatchID_FaCODGrantDisbID_U_N_IDX | Index | ExportBatchID, FaCODGrantDisbId |
| FaCODGrantDisb_FaStudentAidID_FaCODGrantDisbID_U_N_IDX | Index | FaStudentAidID, FaCODGrantDisbId |
| FaCODGrantDisb_FaCODGrantID_FaCODGrantDisbID_U_N_IDX | Index | FaCODGrantID, FaCODGrantDisbId |
| FaCODGrantDisb_FaCODGrantDisbID_U_C_IDX | PrimaryKey | FaCODGrantDisbId |
| FaCODGrantDisb Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| FaCODGrant | Non-Identifying | One To Zero or More | FK_FaCODGrantDisb_FaCODGrantID_FaCODGrant_FaCODGrantID | FaCODGrantID | NO | YES | ||
| FaDisb | Non-Identifying | Zero or One to Zero or More | FK_FaCODGrantDisb_FaCODGrantID_FaDisb_FaDisbID | FaDisbID | NO | YES | ||
| FaRefund | Non-Identifying | Zero or One to Zero or More | FK_FaCODGrantDisb_FaCODGrantID_FaRefund_FaRefundID | FaRefundID | NO | YES | ||
| FaSched | Non-Identifying | Zero or One to Zero or More | FK_FaCODGrantDisb_FaCODGrantID_FaSched_FaSchedID | FaSchedID | NO | YES | ||
| FaStudentAid | Non-Identifying | One To Zero or More | FK_FaCODGrantDisb_FaCODGrantID_FaStudentAid_FaStudentAidID | FaStudentAidID | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_FaCODGrantDisb_UserID_SyStaff_SyStaffID | UserID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| FaCODGrantDisb Check Constraints |
| Check Constraint Name | CheckConstraint |